using System;using System.Drawing;using System.Collections;using System.ComponentModel;using System.Windows.Forms;using System.Data;namespace MyDB{/// <summary>/// Form1 的摘要说明。/// </summary>public class Form1 : System.Windows.Forms.Form{private System.Windows.Forms.Panel panel1;private System.Windows.Forms.Splitter splitter1;private System.Data.OleDb.OleDbConnection oleDbConnection1;private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;private System.Data.DataSet dataSet1;private System.Windows.Forms.DataGrid dataGrid1;private System.Windows.Forms.Button button1;private System.Windows.Forms.Label label1;private System.Windows.Forms.ComboBox comboBox1;private System.Windows.Forms.Label label2;private System.Windows.Forms.TextBox textBox1;private System.Windows.Forms.Button button2;private System.Windows.Forms.Button button3;private System.Windows.Forms.Button button4;private System.Windows.Forms.OpenFileDialog openFileDialog1;private System.Windows.Forms.SaveFileDialog saveFileDialog1;private System.Windows.Forms.RichTextBox richTextBox1;/// <summary>/// 必需的设计器变量。/// </summary>private System.ComponentModel.Container components = null;public Form1(){//// Windows 窗体设计器支持所必需的//InitializeComponent();//// TODO: 在 InitializeComponent 调用后添加任何构造函数代码//}/// <summary>/// 清理所有正在使用的资源。/// </summary>protected override void Dispose( bool disposing ){if( disposing ){if (components != null) {components.Dispose();}}base.Dispose( disposing );}#region Windows 窗体设计器生成的代码/// <summary>/// 设计器支持所需的方法 - 不要使用代码编辑器修改/// 此方法的内容。/// </summary>private void InitializeComponent(){this.panel1 = new System.Windows.Forms.Panel();this.textBox1 = new System.Windows.Forms.TextBox();this.label2 = new System.Windows.Forms.Label();this.comboBox1 = new System.Windows.Forms.ComboBox();this.label1 = new System.Windows.Forms.Label();this.button1 = new System.Windows.Forms.Button();this.splitter1 = new System.Windows.Forms.Splitter();this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();this.dataSet1 = new System.Data.DataSet();this.dataGrid1 = new System.Windows.Forms.DataGrid();this.button2 = new System.Windows.Forms.Button();this.button3 = new System.Windows.Forms.Button();this.button4 = new System.Windows.Forms.Button();this.openFileDialog1 = new System.Windows.Forms.OpenFileDialog();this.saveFileDialog1 = new System.Windows.Forms.SaveFileDialog();this.richTextBox1 = new System.Windows.Forms.RichTextBox();this.panel1.SuspendLayout();((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();this.SuspendLayout();// // panel1// this.panel1.Controls.Add(this.button4);this.panel1.Controls.Add(this.button3);this.panel1.Controls.Add(this.button2);this.panel1.Controls.Add(this.textBox1);this.panel1.Controls.Add(this.label2);this.panel1.Controls.Add(this.comboBox1);this.panel1.Controls.Add(this.label1);this.panel1.Controls.Add(this.button1);this.panel1.Dock = System.Windows.Forms.DockStyle.Top;this.panel1.Location = new System.Drawing.Point(0, 0);this.panel1.Name = "panel1";this.panel1.Size = new System.Drawing.Size(400, 56);this.panel1.TabIndex = 0;// // textBox1// this.textBox1.Location = new System.Drawing.Point(288, 8);this.textBox1.Name = "textBox1";this.textBox1.Size = new System.Drawing.Size(104, 21);this.textBox1.TabIndex = 4;this.textBox1.Text = "";// // label2// this.label2.Location = new System.Drawing.Point(208, 16);this.label2.Name = "label2";this.label2.Size = new System.Drawing.Size(80, 16);this.label2.TabIndex = 3;this.label2.Text = "设置查询值：";// // comboBox1// this.comboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;this.comboBox1.Items.AddRange(new object[] { "客户ID", "公司名称", "联系人姓名", "联系人头衔", "地址", "城市", "地区", "邮政编码", "国家", "电话", "传真", "所有记录"});this.comboBox1.Location = new System.Drawing.Point(96, 8);this.comboBox1.Name = "comboBox1";this.comboBox1.Size = new System.Drawing.Size(104, 20);this.comboBox1.TabIndex = 2;// // label1// this.label1.Location = new System.Drawing.Point(8, 16);this.label1.Name = "label1";this.label1.Size = new System.Drawing.Size(96, 16);this.label1.TabIndex = 1;this.label1.Text = "选择查询条件：";// // button1// this.button1.Location = new System.Drawing.Point(8, 32);this.button1.Name = "button1";this.button1.Size = new System.Drawing.Size(96, 23);this.button1.TabIndex = 0;this.button1.Text = "开始查询";this.button1.Click = new System.EventHandler(this.button1_Click);// // splitter1// this.splitter1.Dock = System.Windows.Forms.DockStyle.Top;this.splitter1.Location = new System.Drawing.Point(0, 56);this.splitter1.Name = "splitter1";this.splitter1.Size = new System.Drawing.Size(400, 3);this.splitter1.TabIndex = 1;this.splitter1.TabStop = false;// // oleDbConnection1// this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""Northwind.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";// // oleDbSelectCommand1// this.oleDbSelectCommand1.CommandText = "SELECT * FROM 客户 ";this.oleDbSelectCommand1.Connection = this.oleDbConnection1;// // oleDbDataAdapter1// this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;// // dataSet1// this.dataSet1.DataSetName = "NewDataSet";this.dataSet1.Locale = new System.Globalization.CultureInfo("zh-CN");// // dataGrid1// this.dataGrid1.CaptionVisible = false;this.dataGrid1.DataMember = "";this.dataGrid1.Dock = System.Windows.Forms.DockStyle.Fill;this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;this.dataGrid1.Location = new System.Drawing.Point(0, 59);this.dataGrid1.Name = "dataGrid1";this.dataGrid1.Size = new System.Drawing.Size(400, 243);this.dataGrid1.TabIndex = 2;// // button2// this.button2.Location = new System.Drawing.Point(104, 32);this.button2.Name = "button2";this.button2.Size = new System.Drawing.Size(96, 23);this.button2.TabIndex = 5;this.button2.Text = "写入XML文件";this.button2.Click = new System.EventHandler(this.button2_Click);// // button3// this.button3.Location = new System.Drawing.Point(200, 32);this.button3.Name = "button3";this.button3.Size = new System.Drawing.Size(96, 23);this.button3.TabIndex = 6;this.button3.Text = "读取XML文件";this.button3.Click = new System.EventHandler(this.button3_Click);// // button4// this.button4.Location = new System.Drawing.Point(296, 32);this.button4.Name = "button4";this.button4.Size = new System.Drawing.Size(96, 23);this.button4.TabIndex = 7;this.button4.Text = "显示XML文件";this.button4.Click = new System.EventHandler(this.button4_Click);// // openFileDialog1// this.openFileDialog1.Filter = "所有XML文件|*.XML";// // saveFileDialog1// this.saveFileDialog1.Filter = "所有XML文件|*.XML";// // richTextBox1// this.richTextBox1.Dock = System.Windows.Forms.DockStyle.Fill;this.richTextBox1.Location = new System.Drawing.Point(0, 59);this.richTextBox1.Name = "richTextBox1";this.richTextBox1.Size = new System.Drawing.Size(400, 243);this.richTextBox1.TabIndex = 3;this.richTextBox1.Text = "";this.richTextBox1.Visible = false;// // Form1// this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);this.ClientSize = new System.Drawing.Size(400, 302);this.Controls.Add(this.richTextBox1);this.Controls.Add(this.dataGrid1);this.Controls.Add(this.splitter1);this.Controls.Add(this.panel1);this.Name = "Form1";this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;this.Text = "演示读写XML文件";this.Load = new System.EventHandler(this.Form1_Load);this.Closed = new System.EventHandler(this.Form1_Closed);this.panel1.ResumeLayout(false);((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();this.ResumeLayout(false);}#endregion/// <summary>/// 应用程序的主入口点。/// </summary>[STAThread]static void Main() {Application.Run(new Form1());}private void Form1_Load(object sender, System.EventArgs e){//显示所有记录this.oleDbDataAdapter1.Fill(this.dataSet1,"客户");this.dataGrid1.DataSource=this.dataSet1;if(!this.dataGrid1.IsExpanded(0)) this.dataGrid1.Expand(0);}private void button1_Click(object sender, System.EventArgs e){//查询记录try{this.dataSet1.Clear();string StrSQL="SELECT * FROM 客户 WHERE ";StrSQL =this.comboBox1.Text " LIKE '";StrSQL =this.textBox1.Text "'";if(this.comboBox1.Text=="所有记录")StrSQL="SELECT * FROM 客户";this.oleDbDataAdapter1.SelectCommand.CommandText=StrSQL;this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;//打开数据库连接this.oleDbConnection1.Open();//执行SQL命令this.oleDbDataAdapter1.SelectCommand.ExecuteNonQuery();//关闭连接this.oleDbConnection1.Close();//更新数据集this.oleDbDataAdapter1.Fill(this.dataSet1,"客户");this.dataGrid1.DataSource=this.dataSet1;this.richTextBox1.Visible=false;this.dataGrid1.Visible=true;}catch(Exception Err){MessageBox.Show("查询数据集记录操作失败：" Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);//如果打开了连接，则关闭它if(this.oleDbConnection1.State==ConnectionState.Open){this.oleDbConnection1.Close();}}}private void Form1_Closed(object sender, System.EventArgs e){//关闭程序//如果打开了连接，则关闭它if(this.oleDbConnection1.State==ConnectionState.Open){this.oleDbConnection1.Close();}}private void button2_Click(object sender, System.EventArgs e){//写入XML文件try{if(this.dataSet1==null)return;if(this.saveFileDialog1.ShowDialog()==DialogResult.Cancel)return;string FileName=this.saveFileDialog1.FileName;if(FileName.Length<1)return;//将数据写入XML文件this.dataSet1.WriteXml(FileName,XmlWriteMode.WriteSchema);MessageBox.Show("写入XML文件操作成功！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);}catch(Exception Err){MessageBox.Show("写入XML文件发生错误：" Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);}}private void button3_Click(object sender, System.EventArgs e){//读取XML文件if(this.openFileDialog1.ShowDialog()==DialogResult.Cancel)return;string FileName=this.openFileDialog1.FileName;if(FileName.Length<1)return;System.Xml.XmlTextReader MyReader=new System.Xml.XmlTextReader(FileName);//从XmlTextReader中读取数据this.dataSet1.ReadXml(MyReader,XmlReadMode.ReadSchema);this.dataGrid1.DataSource=this.dataSet1;this.richTextBox1.Visible=false;this.dataGrid1.Visible=true;}private void button4_Click(object sender, System.EventArgs e){//显示XML文件if(this.dataSet1==null)return;//取得XSD架构数据this.richTextBox1.Text=this.dataSet1.GetXmlSchema();//取得数据this.richTextBox1.Text =this.dataSet1.GetXml();this.richTextBox1.Visible=true;this.dataGrid1.Visible=false;}}}
评论